package com.cls.business.mapper;

import com.cls.business.entity.Indicator;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.cls.business.entity.ReviewDetail;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * 评审指标表 Mapper
 *
 * @author slx
 * @date 2020-11-13 15:14:45
 */
@Repository
public interface IndicatorMapper extends BaseMapper<Indicator> {
    @Select("select indi.name indicator_name," +
        "indi.description indicator_description," +
        "indi.weight weight," +
        "detail.indicator_type," +
        "detail.question_description," +
        "detail.max_score," +
        "detail.min_score " +
        "from biz_indicator_detail  detail " +
        "LEFT JOIN biz_indicator indi on detail.indicator_id = indi.indicator_id " +
        "where indi.is_delete = 0 and detail.is_delete = 0")
    List<ReviewDetail> getReviewDetailTemplate();
}
